Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 8636 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.3 MiB |
| Average record size in memory | 152.0 B |
Variable types
| Numeric | 18 |
|---|---|
| Categorical | 1 |
cust_id has a high cardinality: 8636 distinct values | High cardinality |
balance is highly correlated with balance_frequency and 5 other fields | High correlation |
balance_frequency is highly correlated with balance and 1 other fields | High correlation |
purchases is highly correlated with oneoff_purchases and 5 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 2 other fields | High correlation |
installments_purchases is highly correlated with purchases and 3 other fields | High correlation |
cash_advance is highly correlated with balance and 2 other fields | High correlation |
purchases_frequency is highly correlated with purchases and 3 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with purchases and 2 other fields | High correlation |
purchases_installments_frequency is highly correlated with purchases and 3 other fields | High correlation |
cash_advance_frequency is highly correlated with balance and 2 other fields | High correlation |
cash_advance_trx is highly correlated with balance and 2 other fields | High correlation |
purchases_trx is highly correlated with purchases and 5 other fields | High correlation |
minimum_payments is highly correlated with balance and 1 other fields | High correlation |
prc_full_payment is highly correlated with balance | High correlation |
balance is highly correlated with credit_limit | High correlation |
purchases is highly correlated with oneoff_purchases and 3 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 3 other fields | High correlation |
installments_purchases is highly correlated with purchases and 2 other fields | High correlation |
cash_advance is highly correlated with cash_advance_frequency and 1 other fields | High correlation |
purchases_frequency is highly correlated with oneoff_purchases_frequency and 2 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with oneoff_purchases and 2 other fields | High correlation |
purchases_installments_frequency is highly correlated with installments_purchases and 2 other fields | High correlation |
cash_advance_frequency is highly correlated with cash_advance and 1 other fields | High correlation |
cash_advance_trx is highly correlated with cash_advance and 1 other fields | High correlation |
purchases_trx is highly correlated with purchases and 5 other fields | High correlation |
credit_limit is highly correlated with balance | High correlation |
payments is highly correlated with purchases and 1 other fields | High correlation |
balance is highly correlated with minimum_payments | High correlation |
purchases is highly correlated with oneoff_purchases and 4 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 1 other fields | High correlation |
installments_purchases is highly correlated with purchases and 3 other fields | High correlation |
cash_advance is highly correlated with cash_advance_frequency and 1 other fields | High correlation |
purchases_frequency is highly correlated with purchases and 3 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with purchases and 1 other fields | High correlation |
purchases_installments_frequency is highly correlated with installments_purchases and 2 other fields | High correlation |
cash_advance_frequency is highly correlated with cash_advance and 1 other fields | High correlation |
cash_advance_trx is highly correlated with cash_advance and 1 other fields | High correlation |
purchases_trx is highly correlated with purchases and 3 other fields | High correlation |
minimum_payments is highly correlated with balance | High correlation |
balance is highly correlated with credit_limit | High correlation |
purchases is highly correlated with oneoff_purchases and 4 other fields | High correlation |
oneoff_purchases is highly correlated with purchases and 2 other fields | High correlation |
installments_purchases is highly correlated with purchases and 1 other fields | High correlation |
cash_advance is highly correlated with cash_advance_trx and 1 other fields | High correlation |
purchases_frequency is highly correlated with oneoff_purchases_frequency and 1 other fields | High correlation |
oneoff_purchases_frequency is highly correlated with purchases_frequency | High correlation |
purchases_installments_frequency is highly correlated with purchases_frequency | High correlation |
cash_advance_frequency is highly correlated with cash_advance_trx | High correlation |
cash_advance_trx is highly correlated with cash_advance and 1 other fields | High correlation |
purchases_trx is highly correlated with purchases and 3 other fields | High correlation |
credit_limit is highly correlated with balance and 2 other fields | High correlation |
payments is highly correlated with purchases and 4 other fields | High correlation |
df_index is uniformly distributed | Uniform |
cust_id is uniformly distributed | Uniform |
df_index has unique values | Unique |
cust_id has unique values | Unique |
payments has unique values | Unique |
purchases has 1967 (22.8%) zeros | Zeros |
oneoff_purchases has 4113 (47.6%) zeros | Zeros |
installments_purchases has 3747 (43.4%) zeros | Zeros |
cash_advance has 4431 (51.3%) zeros | Zeros |
purchases_frequency has 1966 (22.8%) zeros | Zeros |
oneoff_purchases_frequency has 4113 (47.6%) zeros | Zeros |
purchases_installments_frequency has 3746 (43.4%) zeros | Zeros |
cash_advance_frequency has 4431 (51.3%) zeros | Zeros |
cash_advance_trx has 4431 (51.3%) zeros | Zeros |
purchases_trx has 1967 (22.8%) zeros | Zeros |
prc_full_payment has 5589 (64.7%) zeros | Zeros |
Reproduction
| Analysis started | 2022-02-23 23:00:03.242437 |
|---|---|
| Analysis finished | 2022-02-23 23:01:10.457290 |
| Duration | 1 minute and 7.21 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 8636 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4476.918828 |
| Minimum | 0 |
|---|---|
| Maximum | 8949 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 468.75 |
| Q1 | 2266.75 |
| median | 4468.5 |
| Q3 | 6697.25 |
| 95-th percentile | 8489.25 |
| Maximum | 8949 |
| Range | 8949 |
| Interquartile range (IQR) | 4430.5 |
Descriptive statistics
| Standard deviation | 2565.759792 |
|---|---|
| Coefficient of variation (CV) | 0.5731084012 |
| Kurtosis | -1.189516908 |
| Mean | 4476.918828 |
| Median Absolute Deviation (MAD) | 2215 |
| Skewness | 0.003298459329 |
| Sum | 38662671 |
| Variance | 6583123.311 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 5945 | 1 | < 0.1% |
| 5959 | 1 | < 0.1% |
| 5958 | 1 | < 0.1% |
| 5957 | 1 | < 0.1% |
| 5956 | 1 | < 0.1% |
| 5955 | 1 | < 0.1% |
| 5954 | 1 | < 0.1% |
| 5953 | 1 | < 0.1% |
| 5952 | 1 | < 0.1% |
| Other values (8626) | 8626 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 8949 | 1 | |
| 8948 | 1 | |
| 8947 | 1 | |
| 8945 | 1 | |
| 8943 | 1 | |
| 8942 | 1 | |
| 8941 | 1 | |
| 8940 | 1 | |
| 8939 | 1 | |
| 8938 | 1 |
| Distinct | 8636 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.6 KiB |
| C10001 | 1 |
|---|---|
| C16111 | 1 |
| C16125 | 1 |
| C16124 | 1 |
| C16123 | 1 |
| Other values (8631) |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 8636 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | C10001 |
|---|---|
| 2nd row | C10002 |
| 3rd row | C10003 |
| 4th row | C10005 |
| 5th row | C10006 |
Common Values
| Value | Count | Frequency (%) |
| C10001 | 1 | < 0.1% |
| C16111 | 1 | < 0.1% |
| C16125 | 1 | < 0.1% |
| C16124 | 1 | < 0.1% |
| C16123 | 1 | < 0.1% |
| C16122 | 1 | < 0.1% |
| C16121 | 1 | < 0.1% |
| C16120 | 1 | < 0.1% |
| C16119 | 1 | < 0.1% |
| C16118 | 1 | < 0.1% |
| Other values (8626) | 8626 |
Length
| Value | Count | Frequency (%) |
| c10001 | 1 | < 0.1% |
| c10020 | 1 | < 0.1% |
| c10006 | 1 | < 0.1% |
| c10007 | 1 | < 0.1% |
| c10008 | 1 | < 0.1% |
| c10009 | 1 | < 0.1% |
| c10010 | 1 | < 0.1% |
| c10011 | 1 | < 0.1% |
| c10012 | 1 | < 0.1% |
| c10013 | 1 | < 0.1% |
| Other values (8626) | 8626 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 8631 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1601.224893 |
| Minimum | 0 |
|---|---|
| Maximum | 19043.13856 |
| Zeros | 6 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13.209472 |
| Q1 | 148.095189 |
| median | 916.855459 |
| Q3 | 2105.195853 |
| 95-th percentile | 5936.635587 |
| Maximum | 19043.13856 |
| Range | 19043.13856 |
| Interquartile range (IQR) | 1957.100664 |
Descriptive statistics
| Standard deviation | 2095.5713 |
|---|---|
| Coefficient of variation (CV) | 1.308730154 |
| Kurtosis | 7.55387602 |
| Mean | 1601.224893 |
| Median Absolute Deviation (MAD) | 825.6064455 |
| Skewness | 2.374254167 |
| Sum | 13828178.17 |
| Variance | 4391419.074 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6 | 0.1% |
| 40.900749 | 1 | < 0.1% |
| 1253.188317 | 1 | < 0.1% |
| 394.643543 | 1 | < 0.1% |
| 617.413726 | 1 | < 0.1% |
| 765.109593 | 1 | < 0.1% |
| 2583.247881 | 1 | < 0.1% |
| 1146.669364 | 1 | < 0.1% |
| 757.470201 | 1 | < 0.1% |
| 5058.299635 | 1 | < 0.1% |
| Other values (8621) | 8621 |
| Value | Count | Frequency (%) |
| 0 | 6 | |
| 0.000199 | 1 | < 0.1% |
| 0.001146 | 1 | < 0.1% |
| 0.001214 | 1 | < 0.1% |
| 0.001289 | 1 | < 0.1% |
| 0.004816 | 1 | < 0.1% |
| 0.009684 | 1 | < 0.1% |
| 0.064811 | 1 | < 0.1% |
| 0.065402 | 1 | < 0.1% |
| 0.074724 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 19043.13856 | 1 | |
| 18495.55855 | 1 | |
| 16304.88925 | 1 | |
| 16259.44857 | 1 | |
| 16115.5964 | 1 | |
| 15532.33972 | 1 | |
| 15258.2259 | 1 | |
| 15244.74865 | 1 | |
| 15155.53286 | 1 | |
| 14581.45914 | 1 |
| Distinct | 42 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8950351114 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 6 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.363636 |
| Q1 | 0.909091 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.090909 |
Descriptive statistics
| Standard deviation | 0.2076968758 |
|---|---|
| Coefficient of variation (CV) | 0.2320544447 |
| Kurtosis | 3.369586149 |
| Mean | 0.8950351114 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.084161482 |
| Sum | 7729.523222 |
| Variance | 0.0431379922 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 6130 | |
| 0.909091 | 406 | 4.7% |
| 0.818182 | 274 | 3.2% |
| 0.727273 | 220 | 2.5% |
| 0.545455 | 217 | 2.5% |
| 0.636364 | 202 | 2.3% |
| 0.454545 | 170 | 2.0% |
| 0.363636 | 167 | 1.9% |
| 0.272727 | 141 | 1.6% |
| 0.181818 | 117 | 1.4% |
| Other values (32) | 592 | 6.9% |
| Value | Count | Frequency (%) |
| 0 | 6 | 0.1% |
| 0.090909 | 25 | 0.3% |
| 0.1 | 2 | < 0.1% |
| 0.125 | 2 | < 0.1% |
| 0.142857 | 1 | < 0.1% |
| 0.166667 | 1 | < 0.1% |
| 0.181818 | 117 | |
| 0.2 | 7 | 0.1% |
| 0.222222 | 2 | < 0.1% |
| 0.25 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 6130 | |
| 0.909091 | 406 | 4.7% |
| 0.9 | 55 | 0.6% |
| 0.888889 | 53 | 0.6% |
| 0.875 | 57 | 0.7% |
| 0.857143 | 50 | 0.6% |
| 0.833333 | 59 | 0.7% |
| 0.818182 | 274 | 3.2% |
| 0.8 | 20 | 0.2% |
| 0.777778 | 21 | 0.2% |
purchases
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 6015 |
|---|---|
| Distinct (%) | 69.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1025.433874 |
| Minimum | 0 |
|---|---|
| Maximum | 49039.57 |
| Zeros | 1967 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 43.3675 |
| median | 375.405 |
| Q3 | 1145.98 |
| 95-th percentile | 4060.0925 |
| Maximum | 49039.57 |
| Range | 49039.57 |
| Interquartile range (IQR) | 1102.6125 |
Descriptive statistics
| Standard deviation | 2167.107984 |
|---|---|
| Coefficient of variation (CV) | 2.113357124 |
| Kurtosis | 108.677684 |
| Mean | 1025.433874 |
| Median Absolute Deviation (MAD) | 375.405 |
| Skewness | 8.055789007 |
| Sum | 8855646.94 |
| Variance | 4696357.014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1967 | 22.8% |
| 45.65 | 25 | 0.3% |
| 150 | 15 | 0.2% |
| 60 | 13 | 0.2% |
| 200 | 12 | 0.1% |
| 450 | 12 | 0.1% |
| 100 | 12 | 0.1% |
| 600 | 10 | 0.1% |
| 70 | 10 | 0.1% |
| 1000 | 9 | 0.1% |
| Other values (6005) | 6551 |
| Value | Count | Frequency (%) |
| 0 | 1967 | |
| 0.01 | 3 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.24 | 1 | < 0.1% |
| 1 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
| 4.44 | 1 | < 0.1% |
| 4.8 | 1 | < 0.1% |
| 4.99 | 1 | < 0.1% |
| 6.9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49039.57 | 1 | |
| 41050.4 | 1 | |
| 40040.71 | 1 | |
| 38902.71 | 1 | |
| 35131.16 | 1 | |
| 32539.78 | 1 | |
| 31299.35 | 1 | |
| 27957.68 | 1 | |
| 27790.42 | 1 | |
| 26784.62 | 1 |
oneoff_purchases
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 3922 |
|---|---|
| Distinct (%) | 45.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 604.9014382 |
| Minimum | 0 |
|---|---|
| Maximum | 40761.25 |
| Zeros | 4113 |
| Zeros (%) | 47.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 44.995 |
| Q3 | 599.1 |
| 95-th percentile | 2728.3725 |
| Maximum | 40761.25 |
| Range | 40761.25 |
| Interquartile range (IQR) | 599.1 |
Descriptive statistics
| Standard deviation | 1684.307803 |
|---|---|
| Coefficient of variation (CV) | 2.784433458 |
| Kurtosis | 160.1213079 |
| Mean | 604.9014382 |
| Median Absolute Deviation (MAD) | 44.995 |
| Skewness | 9.935775933 |
| Sum | 5223928.82 |
| Variance | 2836892.776 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4113 | |
| 45.65 | 43 | 0.5% |
| 50 | 16 | 0.2% |
| 200 | 15 | 0.2% |
| 70 | 12 | 0.1% |
| 150 | 12 | 0.1% |
| 1000 | 12 | 0.1% |
| 100 | 12 | 0.1% |
| 250 | 11 | 0.1% |
| 60 | 10 | 0.1% |
| Other values (3912) | 4380 |
| Value | Count | Frequency (%) |
| 0 | 4113 | |
| 0.01 | 6 | 0.1% |
| 0.02 | 2 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.24 | 1 | < 0.1% |
| 1 | 4 | < 0.1% |
| 1.4 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 4.99 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40761.25 | 1 | |
| 40624.06 | 1 | |
| 34087.73 | 1 | |
| 33803.84 | 1 | |
| 26547.43 | 1 | |
| 26514.32 | 1 | |
| 25122.77 | 1 | |
| 24543.52 | 1 | |
| 23032.97 | 1 | |
| 22257.39 | 1 |
installments_purchases
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 4341 |
|---|---|
| Distinct (%) | 50.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 420.8435329 |
| Minimum | 0 |
|---|---|
| Maximum | 22500 |
| Zeros | 3747 |
| Zeros (%) | 43.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 94.785 |
| Q3 | 484.1475 |
| 95-th percentile | 1800 |
| Maximum | 22500 |
| Range | 22500 |
| Interquartile range (IQR) | 484.1475 |
Descriptive statistics
| Standard deviation | 917.2451825 |
|---|---|
| Coefficient of variation (CV) | 2.179539688 |
| Kurtosis | 94.19337343 |
| Mean | 420.8435329 |
| Median Absolute Deviation (MAD) | 94.785 |
| Skewness | 7.216133309 |
| Sum | 3634404.75 |
| Variance | 841338.7248 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3747 | |
| 100 | 14 | 0.2% |
| 200 | 13 | 0.2% |
| 125 | 11 | 0.1% |
| 150 | 11 | 0.1% |
| 300 | 10 | 0.1% |
| 75 | 9 | 0.1% |
| 450 | 8 | 0.1% |
| 500 | 8 | 0.1% |
| 270 | 7 | 0.1% |
| Other values (4331) | 4798 |
| Value | Count | Frequency (%) |
| 0 | 3747 | |
| 1.95 | 1 | < 0.1% |
| 4.44 | 1 | < 0.1% |
| 4.8 | 1 | < 0.1% |
| 6.33 | 1 | < 0.1% |
| 7.26 | 1 | < 0.1% |
| 7.67 | 1 | < 0.1% |
| 9.58 | 1 | < 0.1% |
| 9.65 | 1 | < 0.1% |
| 9.68 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 22500 | 1 | |
| 15497.19 | 1 | |
| 14686.1 | 1 | |
| 13184.43 | 1 | |
| 12738.47 | 1 | |
| 12560.85 | 1 | |
| 12541 | 1 | |
| 12375 | 1 | |
| 12235.05 | 1 | |
| 12128.94 | 1 |
cash_advance
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 4206 |
|---|---|
| Distinct (%) | 48.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 994.175523 |
| Minimum | 0 |
|---|---|
| Maximum | 47137.21176 |
| Zeros | 4431 |
| Zeros (%) | 51.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1132.38549 |
| 95-th percentile | 4721.415498 |
| Maximum | 47137.21176 |
| Range | 47137.21176 |
| Interquartile range (IQR) | 1132.38549 |
Descriptive statistics
| Standard deviation | 2121.458303 |
|---|---|
| Coefficient of variation (CV) | 2.133887079 |
| Kurtosis | 52.14352309 |
| Mean | 994.175523 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.139628566 |
| Sum | 8585699.817 |
| Variance | 4500585.331 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4431 | |
| 2411.584248 | 1 | < 0.1% |
| 92.6579 | 1 | < 0.1% |
| 1486.243293 | 1 | < 0.1% |
| 855.232779 | 1 | < 0.1% |
| 3767.104707 | 1 | < 0.1% |
| 291.608512 | 1 | < 0.1% |
| 38.690552 | 1 | < 0.1% |
| 521.664369 | 1 | < 0.1% |
| 1974.202963 | 1 | < 0.1% |
| Other values (4196) | 4196 |
| Value | Count | Frequency (%) |
| 0 | 4431 | |
| 14.222216 | 1 | < 0.1% |
| 18.042768 | 1 | < 0.1% |
| 18.117967 | 1 | < 0.1% |
| 18.123413 | 1 | < 0.1% |
| 18.126683 | 1 | < 0.1% |
| 18.149946 | 1 | < 0.1% |
| 18.204577 | 1 | < 0.1% |
| 18.240626 | 1 | < 0.1% |
| 18.280043 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 47137.21176 | 1 | |
| 29282.10915 | 1 | |
| 27296.48576 | 1 | |
| 26268.69989 | 1 | |
| 26194.04954 | 1 | |
| 23130.82106 | 1 | |
| 22665.7785 | 1 | |
| 21943.84942 | 1 | |
| 20712.67008 | 1 | |
| 20277.33112 | 1 |
purchases_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.4960000002 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 1966 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.083333 |
| median | 0.5 |
| Q3 | 0.916667 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.833334 |
Descriptive statistics
| Standard deviation | 0.4012726404 |
|---|---|
| Coefficient of variation (CV) | 0.8090174198 |
| Kurtosis | -1.638001348 |
| Mean | 0.4960000002 |
| Median Absolute Deviation (MAD) | 0.416667 |
| Skewness | 0.03304121629 |
| Sum | 4283.456002 |
| Variance | 0.161019732 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 2126 | |
| 0 | 1966 | |
| 0.083333 | 622 | 7.2% |
| 0.916667 | 391 | 4.5% |
| 0.5 | 390 | 4.5% |
| 0.833333 | 367 | 4.2% |
| 0.166667 | 367 | 4.2% |
| 0.333333 | 350 | 4.1% |
| 0.25 | 328 | 3.8% |
| 0.583333 | 309 | 3.6% |
| Other values (37) | 1420 |
| Value | Count | Frequency (%) |
| 0 | 1966 | |
| 0.083333 | 622 | 7.2% |
| 0.090909 | 41 | 0.5% |
| 0.1 | 23 | 0.3% |
| 0.111111 | 16 | 0.2% |
| 0.125 | 25 | 0.3% |
| 0.142857 | 22 | 0.3% |
| 0.166667 | 367 | 4.2% |
| 0.181818 | 15 | 0.2% |
| 0.2 | 17 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 2126 | |
| 0.916667 | 391 | 4.5% |
| 0.909091 | 28 | 0.3% |
| 0.9 | 23 | 0.3% |
| 0.888889 | 18 | 0.2% |
| 0.875 | 26 | 0.3% |
| 0.857143 | 23 | 0.3% |
| 0.833333 | 367 | 4.2% |
| 0.818182 | 20 | 0.2% |
| 0.8 | 9 | 0.1% |
oneoff_purchases_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2059087409 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 4113 |
| Zeros (%) | 47.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.083333 |
| Q3 | 0.333333 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.333333 |
Descriptive statistics
| Standard deviation | 0.3000536066 |
|---|---|
| Coefficient of variation (CV) | 1.457216461 |
| Kurtosis | 1.05820574 |
| Mean | 0.2059087409 |
| Median Absolute Deviation (MAD) | 0.083333 |
| Skewness | 1.504234233 |
| Sum | 1778.227886 |
| Variance | 0.09003216681 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4113 | |
| 0.083333 | 1057 | 12.2% |
| 0.166667 | 576 | 6.7% |
| 1 | 469 | 5.4% |
| 0.25 | 408 | 4.7% |
| 0.333333 | 346 | 4.0% |
| 0.416667 | 243 | 2.8% |
| 0.5 | 232 | 2.7% |
| 0.583333 | 197 | 2.3% |
| 0.666667 | 167 | 1.9% |
| Other values (37) | 828 | 9.6% |
| Value | Count | Frequency (%) |
| 0 | 4113 | |
| 0.083333 | 1057 | 12.2% |
| 0.090909 | 54 | 0.6% |
| 0.1 | 36 | 0.4% |
| 0.111111 | 24 | 0.3% |
| 0.125 | 35 | 0.4% |
| 0.142857 | 33 | 0.4% |
| 0.166667 | 576 | 6.7% |
| 0.181818 | 33 | 0.4% |
| 0.2 | 26 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 469 | |
| 0.916667 | 151 | 1.7% |
| 0.909091 | 4 | < 0.1% |
| 0.9 | 1 | < 0.1% |
| 0.888889 | 2 | < 0.1% |
| 0.875 | 6 | 0.1% |
| 0.857143 | 1 | < 0.1% |
| 0.833333 | 115 | 1.3% |
| 0.818182 | 10 | 0.1% |
| 0.8 | 4 | < 0.1% |
purchases_installments_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3688203456 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 3746 |
| Zeros (%) | 43.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.166667 |
| Q3 | 0.75 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.3980929442 |
|---|---|
| Coefficient of variation (CV) | 1.079368177 |
| Kurtosis | -1.4192794 |
| Mean | 0.3688203456 |
| Median Absolute Deviation (MAD) | 0.166667 |
| Skewness | 0.4877529543 |
| Sum | 3185.132505 |
| Variance | 0.1584779922 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3746 | |
| 1 | 1297 | 15.0% |
| 0.416667 | 381 | 4.4% |
| 0.916667 | 340 | 3.9% |
| 0.833333 | 304 | 3.5% |
| 0.5 | 303 | 3.5% |
| 0.166667 | 296 | 3.4% |
| 0.666667 | 290 | 3.4% |
| 0.75 | 284 | 3.3% |
| 0.083333 | 249 | 2.9% |
| Other values (37) | 1146 | 13.3% |
| Value | Count | Frequency (%) |
| 0 | 3746 | |
| 0.083333 | 249 | 2.9% |
| 0.090909 | 10 | 0.1% |
| 0.1 | 5 | 0.1% |
| 0.111111 | 8 | 0.1% |
| 0.125 | 4 | < 0.1% |
| 0.142857 | 5 | 0.1% |
| 0.166667 | 296 | 3.4% |
| 0.181818 | 14 | 0.2% |
| 0.2 | 8 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1297 | |
| 0.916667 | 340 | 3.9% |
| 0.909091 | 25 | 0.3% |
| 0.9 | 18 | 0.2% |
| 0.888889 | 28 | 0.3% |
| 0.875 | 28 | 0.3% |
| 0.857143 | 29 | 0.3% |
| 0.833333 | 304 | 3.5% |
| 0.818182 | 20 | 0.2% |
| 0.8 | 17 | 0.2% |
cash_advance_frequency
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 54 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1376042043 |
| Minimum | 0 |
|---|---|
| Maximum | 1.5 |
| Zeros | 4431 |
| Zeros (%) | 51.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.25 |
| 95-th percentile | 0.583333 |
| Maximum | 1.5 |
| Range | 1.5 |
| Interquartile range (IQR) | 0.25 |
Descriptive statistics
| Standard deviation | 0.2017914306 |
|---|---|
| Coefficient of variation (CV) | 1.466462683 |
| Kurtosis | 3.184233316 |
| Mean | 0.1376042043 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.795915039 |
| Sum | 1188.349908 |
| Variance | 0.04071978147 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4431 | |
| 0.083333 | 980 | 11.3% |
| 0.166667 | 730 | 8.5% |
| 0.25 | 573 | 6.6% |
| 0.333333 | 434 | 5.0% |
| 0.416667 | 272 | 3.1% |
| 0.5 | 209 | 2.4% |
| 0.583333 | 142 | 1.6% |
| 0.666667 | 124 | 1.4% |
| 0.090909 | 66 | 0.8% |
| Other values (44) | 675 | 7.8% |
| Value | Count | Frequency (%) |
| 0 | 4431 | |
| 0.083333 | 980 | 11.3% |
| 0.090909 | 66 | 0.8% |
| 0.1 | 36 | 0.4% |
| 0.111111 | 23 | 0.3% |
| 0.125 | 43 | 0.5% |
| 0.142857 | 43 | 0.5% |
| 0.166667 | 730 | 8.5% |
| 0.181818 | 41 | 0.5% |
| 0.2 | 21 | 0.2% |
| Value | Count | Frequency (%) |
| 1.5 | 1 | < 0.1% |
| 1.25 | 1 | < 0.1% |
| 1.166667 | 2 | < 0.1% |
| 1.142857 | 1 | < 0.1% |
| 1.125 | 1 | < 0.1% |
| 1.1 | 1 | < 0.1% |
| 1.090909 | 1 | < 0.1% |
| 1 | 24 | |
| 0.916667 | 27 | |
| 0.909091 | 3 | < 0.1% |
cash_advance_trx
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 65 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.313918481 |
| Minimum | 0 |
|---|---|
| Maximum | 123 |
| Zeros | 4431 |
| Zeros (%) | 51.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4 |
| 95-th percentile | 15 |
| Maximum | 123 |
| Range | 123 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 6.912506117 |
|---|---|
| Coefficient of variation (CV) | 2.085901074 |
| Kurtosis | 60.42852324 |
| Mean | 3.313918481 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.67332683 |
| Sum | 28619 |
| Variance | 47.78274082 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4431 | |
| 1 | 839 | 9.7% |
| 2 | 602 | 7.0% |
| 3 | 429 | 5.0% |
| 4 | 374 | 4.3% |
| 5 | 300 | 3.5% |
| 6 | 241 | 2.8% |
| 7 | 202 | 2.3% |
| 8 | 169 | 2.0% |
| 10 | 147 | 1.7% |
| Other values (55) | 902 | 10.4% |
| Value | Count | Frequency (%) |
| 0 | 4431 | |
| 1 | 839 | 9.7% |
| 2 | 602 | 7.0% |
| 3 | 429 | 5.0% |
| 4 | 374 | 4.3% |
| 5 | 300 | 3.5% |
| 6 | 241 | 2.8% |
| 7 | 202 | 2.3% |
| 8 | 169 | 2.0% |
| 9 | 108 | 1.3% |
| Value | Count | Frequency (%) |
| 123 | 3 | |
| 110 | 1 | < 0.1% |
| 107 | 1 | < 0.1% |
| 93 | 1 | < 0.1% |
| 80 | 1 | < 0.1% |
| 71 | 1 | < 0.1% |
| 69 | 1 | < 0.1% |
| 63 | 1 | < 0.1% |
| 62 | 3 | |
| 61 | 1 | < 0.1% |
purchases_trx
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 173 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.03323298 |
| Minimum | 0 |
|---|---|
| Maximum | 358 |
| Zeros | 1967 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 7 |
| Q3 | 18 |
| 95-th percentile | 59 |
| Maximum | 358 |
| Range | 358 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 25.1804684 |
|---|---|
| Coefficient of variation (CV) | 1.674986906 |
| Kurtosis | 33.95227887 |
| Mean | 15.03323298 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 4.578418451 |
| Sum | 129827 |
| Variance | 634.0559887 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 1967 | |
| 1 | 606 | 7.0% |
| 12 | 537 | 6.2% |
| 2 | 345 | 4.0% |
| 6 | 340 | 3.9% |
| 3 | 294 | 3.4% |
| 4 | 277 | 3.2% |
| 7 | 265 | 3.1% |
| 8 | 263 | 3.0% |
| 5 | 254 | 2.9% |
| Other values (163) | 3488 |
| Value | Count | Frequency (%) |
| 0 | 1967 | |
| 1 | 606 | 7.0% |
| 2 | 345 | 4.0% |
| 3 | 294 | 3.4% |
| 4 | 277 | 3.2% |
| 5 | 254 | 2.9% |
| 6 | 340 | 3.9% |
| 7 | 265 | 3.1% |
| 8 | 263 | 3.0% |
| 9 | 240 | 2.8% |
| Value | Count | Frequency (%) |
| 358 | 1 | |
| 347 | 1 | |
| 344 | 1 | |
| 309 | 1 | |
| 308 | 1 | |
| 298 | 1 | |
| 274 | 1 | |
| 273 | 1 | |
| 254 | 1 | |
| 248 | 2 |
| Distinct | 203 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4522.09103 |
| Minimum | 50 |
|---|---|
| Maximum | 30000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 1600 |
| median | 3000 |
| Q3 | 6500 |
| 95-th percentile | 12000 |
| Maximum | 30000 |
| Range | 29950 |
| Interquartile range (IQR) | 4900 |
Descriptive statistics
| Standard deviation | 3659.240379 |
|---|---|
| Coefficient of variation (CV) | 0.8091921094 |
| Kurtosis | 2.773473055 |
| Mean | 4522.09103 |
| Median Absolute Deviation (MAD) | 1800 |
| Skewness | 1.507019041 |
| Sum | 39052778.13 |
| Variance | 13390040.15 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3000 | 752 | 8.7% |
| 1500 | 695 | 8.0% |
| 1200 | 597 | 6.9% |
| 1000 | 596 | 6.9% |
| 2500 | 584 | 6.8% |
| 4000 | 471 | 5.5% |
| 6000 | 449 | 5.2% |
| 5000 | 370 | 4.3% |
| 2000 | 364 | 4.2% |
| 7500 | 273 | 3.2% |
| Other values (193) | 3485 |
| Value | Count | Frequency (%) |
| 50 | 1 | < 0.1% |
| 150 | 5 | 0.1% |
| 200 | 3 | < 0.1% |
| 300 | 14 | 0.2% |
| 400 | 3 | < 0.1% |
| 450 | 6 | 0.1% |
| 500 | 112 | |
| 600 | 21 | 0.2% |
| 650 | 1 | < 0.1% |
| 700 | 20 | 0.2% |
| Value | Count | Frequency (%) |
| 30000 | 2 | < 0.1% |
| 28000 | 1 | < 0.1% |
| 25000 | 1 | < 0.1% |
| 23000 | 2 | < 0.1% |
| 22500 | 1 | < 0.1% |
| 22000 | 1 | < 0.1% |
| 21500 | 2 | < 0.1% |
| 21000 | 2 | < 0.1% |
| 20500 | 1 | < 0.1% |
| 20000 | 10 |
| Distinct | 8636 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1784.478099 |
| Minimum | 0.049513 |
|---|---|
| Maximum | 50721.48336 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0.049513 |
|---|---|
| 5-th percentile | 143.5595672 |
| Q1 | 418.5592373 |
| median | 896.675701 |
| Q3 | 1951.14209 |
| 95-th percentile | 6152.318659 |
| Maximum | 50721.48336 |
| Range | 50721.43385 |
| Interquartile range (IQR) | 1532.582853 |
Descriptive statistics
| Standard deviation | 2909.81009 |
|---|---|
| Coefficient of variation (CV) | 1.630622473 |
| Kurtosis | 54.27081446 |
| Mean | 1784.478099 |
| Median Absolute Deviation (MAD) | 592.6225195 |
| Skewness | 5.873048587 |
| Sum | 15410752.86 |
| Variance | 8466994.762 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 201.802084 | 1 | < 0.1% |
| 6372.619037 | 1 | < 0.1% |
| 162.949236 | 1 | < 0.1% |
| 164.403739 | 1 | < 0.1% |
| 1679.00486 | 1 | < 0.1% |
| 209.392729 | 1 | < 0.1% |
| 1014.549633 | 1 | < 0.1% |
| 272.517748 | 1 | < 0.1% |
| 32.924384 | 1 | < 0.1% |
| 1899.738286 | 1 | < 0.1% |
| Other values (8626) | 8626 |
| Value | Count | Frequency (%) |
| 0.049513 | 1 | |
| 0.056466 | 1 | |
| 3.500505 | 1 | |
| 4.523555 | 1 | |
| 4.841543 | 1 | |
| 9.533313 | 1 | |
| 12.773144 | 1 | |
| 14.500688 | 1 | |
| 16.385421 | 1 | |
| 18.125527 | 1 |
| Value | Count | Frequency (%) |
| 50721.48336 | 1 | |
| 46930.59824 | 1 | |
| 40627.59524 | 1 | |
| 39461.9658 | 1 | |
| 39048.59762 | 1 | |
| 36066.75068 | 1 | |
| 35843.62593 | 1 | |
| 34107.07499 | 1 | |
| 33994.72785 | 1 | |
| 33486.31044 | 1 |
| Distinct | 8635 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 864.3049429 |
| Minimum | 0.019163 |
|---|---|
| Maximum | 76406.20752 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0.019163 |
|---|---|
| 5-th percentile | 73.3585415 |
| Q1 | 169.1635455 |
| median | 312.4522915 |
| Q3 | 825.4964627 |
| 95-th percentile | 2766.593894 |
| Maximum | 76406.20752 |
| Range | 76406.18836 |
| Interquartile range (IQR) | 656.3329173 |
Descriptive statistics
| Standard deviation | 2372.56635 |
|---|---|
| Coefficient of variation (CV) | 2.745057019 |
| Kurtosis | 283.9630416 |
| Mean | 864.3049429 |
| Median Absolute Deviation (MAD) | 190.372786 |
| Skewness | 13.62219309 |
| Sum | 7464137.487 |
| Variance | 5629071.086 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 299.351881 | 2 | < 0.1% |
| 342.28649 | 1 | < 0.1% |
| 184.464721 | 1 | < 0.1% |
| 276.486072 | 1 | < 0.1% |
| 309.140865 | 1 | < 0.1% |
| 354.281114 | 1 | < 0.1% |
| 216.090433 | 1 | < 0.1% |
| 277.546713 | 1 | < 0.1% |
| 150.317143 | 1 | < 0.1% |
| 1600.26917 | 1 | < 0.1% |
| Other values (8625) | 8625 |
| Value | Count | Frequency (%) |
| 0.019163 | 1 | |
| 0.037744 | 1 | |
| 0.05588 | 1 | |
| 0.059481 | 1 | |
| 0.117036 | 1 | |
| 0.261984 | 1 | |
| 0.311953 | 1 | |
| 0.319475 | 1 | |
| 1.113027 | 1 | |
| 1.334075 | 1 |
| Value | Count | Frequency (%) |
| 76406.20752 | 1 | |
| 61031.6186 | 1 | |
| 56370.04117 | 1 | |
| 50260.75947 | 1 | |
| 43132.72823 | 1 | |
| 42629.55117 | 1 | |
| 38512.12477 | 1 | |
| 31871.36379 | 1 | |
| 30528.4324 | 1 | |
| 29019.80288 | 1 |
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1593036248 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 5589 |
| Zeros (%) | 64.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.166667 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.166667 |
Descriptive statistics
| Standard deviation | 0.2962709094 |
|---|---|
| Coefficient of variation (CV) | 1.859787621 |
| Kurtosis | 2.201598481 |
| Mean | 0.1593036248 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.88602713 |
| Sum | 1375.746104 |
| Variance | 0.08777645176 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5589 | |
| 1 | 488 | 5.7% |
| 0.083333 | 426 | 4.9% |
| 0.166667 | 166 | 1.9% |
| 0.5 | 156 | 1.8% |
| 0.25 | 156 | 1.8% |
| 0.090909 | 153 | 1.8% |
| 0.333333 | 134 | 1.6% |
| 0.1 | 94 | 1.1% |
| 0.2 | 83 | 1.0% |
| Other values (37) | 1191 | 13.8% |
| Value | Count | Frequency (%) |
| 0 | 5589 | |
| 0.083333 | 426 | 4.9% |
| 0.090909 | 153 | 1.8% |
| 0.1 | 94 | 1.1% |
| 0.111111 | 61 | 0.7% |
| 0.125 | 52 | 0.6% |
| 0.142857 | 54 | 0.6% |
| 0.166667 | 166 | 1.9% |
| 0.181818 | 75 | 0.9% |
| 0.2 | 83 | 1.0% |
| Value | Count | Frequency (%) |
| 1 | 488 | |
| 0.916667 | 77 | 0.9% |
| 0.909091 | 19 | 0.2% |
| 0.9 | 16 | 0.2% |
| 0.888889 | 12 | 0.1% |
| 0.875 | 18 | 0.2% |
| 0.857143 | 12 | 0.1% |
| 0.833333 | 63 | 0.7% |
| 0.818182 | 17 | 0.2% |
| 0.8 | 33 | 0.4% |
tenure
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.53439092 |
| Minimum | 6 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.6 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 12 |
| median | 12 |
| Q3 | 12 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.310983661 |
|---|---|
| Coefficient of variation (CV) | 0.1136586812 |
| Kurtosis | 8.15670142 |
| Mean | 11.53439092 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -3.011140523 |
| Sum | 99611 |
| Variance | 1.718678158 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 7346 | |
| 11 | 356 | 4.1% |
| 10 | 226 | 2.6% |
| 6 | 184 | 2.1% |
| 8 | 183 | 2.1% |
| 7 | 177 | 2.0% |
| 9 | 164 | 1.9% |
| Value | Count | Frequency (%) |
| 6 | 184 | 2.1% |
| 7 | 177 | 2.0% |
| 8 | 183 | 2.1% |
| 9 | 164 | 1.9% |
| 10 | 226 | 2.6% |
| 11 | 356 | 4.1% |
| 12 | 7346 |
| Value | Count | Frequency (%) |
| 12 | 7346 | |
| 11 | 356 | 4.1% |
| 10 | 226 | 2.6% |
| 9 | 164 | 1.9% |
| 8 | 183 | 2.1% |
| 7 | 177 | 2.0% |
| 6 | 184 | 2.1% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | cust_id | balance | balance_frequency | purchases | oneoff_purchases | installments_purchases | cash_advance | purchases_frequency | oneoff_purchases_frequency | purchases_installments_frequency | cash_advance_frequency | cash_advance_trx | purchases_trx | credit_limit | payments | minimum_payments | prc_full_payment | tenure | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | C10001 | 40.900749 | 0.818182 | 95.40 | 0.00 | 95.40 | 0.000000 | 0.166667 | 0.000000 | 0.083333 | 0.00 | 0 | 2 | 1000.0 | 201.802084 | 139.509787 | 0.000000 | 12 |
| 1 | 1 | C10002 | 3202.467416 | 0.909091 | 0.00 | 0.00 | 0.00 | 6442.945483 | 0.000000 | 0.000000 | 0.000000 | 0.25 | 4 | 0 | 7000.0 | 4103.032597 | 1072.340217 | 0.222222 | 12 |
| 2 | 2 | C10003 | 2495.148862 | 1.000000 | 773.17 | 773.17 | 0.00 | 0.000000 | 1.000000 | 1.000000 | 0.000000 | 0.00 | 0 | 12 | 7500.0 | 622.066742 | 627.284787 | 0.000000 | 12 |
| 3 | 4 | C10005 | 817.714335 | 1.000000 | 16.00 | 16.00 | 0.00 | 0.000000 | 0.083333 | 0.083333 | 0.000000 | 0.00 | 0 | 1 | 1200.0 | 678.334763 | 244.791237 | 0.000000 | 12 |
| 4 | 5 | C10006 | 1809.828751 | 1.000000 | 1333.28 | 0.00 | 1333.28 | 0.000000 | 0.666667 | 0.000000 | 0.583333 | 0.00 | 0 | 8 | 1800.0 | 1400.057770 | 2407.246035 | 0.000000 | 12 |
| 5 | 6 | C10007 | 627.260806 | 1.000000 | 7091.01 | 6402.63 | 688.38 | 0.000000 | 1.000000 | 1.000000 | 1.000000 | 0.00 | 0 | 64 | 13500.0 | 6354.314328 | 198.065894 | 1.000000 | 12 |
| 6 | 7 | C10008 | 1823.652743 | 1.000000 | 436.20 | 0.00 | 436.20 | 0.000000 | 1.000000 | 0.000000 | 1.000000 | 0.00 | 0 | 12 | 2300.0 | 679.065082 | 532.033990 | 0.000000 | 12 |
| 7 | 8 | C10009 | 1014.926473 | 1.000000 | 861.49 | 661.49 | 200.00 | 0.000000 | 0.333333 | 0.083333 | 0.250000 | 0.00 | 0 | 5 | 7000.0 | 688.278568 | 311.963409 | 0.000000 | 12 |
| 8 | 9 | C10010 | 152.225975 | 0.545455 | 1281.60 | 1281.60 | 0.00 | 0.000000 | 0.166667 | 0.166667 | 0.000000 | 0.00 | 0 | 3 | 11000.0 | 1164.770591 | 100.302262 | 0.000000 | 12 |
| 9 | 10 | C10011 | 1293.124939 | 1.000000 | 920.12 | 0.00 | 920.12 | 0.000000 | 1.000000 | 0.000000 | 1.000000 | 0.00 | 0 | 12 | 1200.0 | 1083.301007 | 2172.697765 | 0.000000 | 12 |
Last rows
| df_index | cust_id | balance | balance_frequency | purchases | oneoff_purchases | installments_purchases | cash_advance | purchases_frequency | oneoff_purchases_frequency | purchases_installments_frequency | cash_advance_frequency | cash_advance_trx | purchases_trx | credit_limit | payments | minimum_payments | prc_full_payment | tenure | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8626 | 8938 | C19179 | 78.818407 | 0.500000 | 0.00 | 0.00 | 0.00 | 1113.186078 | 0.000000 | 0.000000 | 0.000000 | 0.166667 | 7 | 0 | 1200.0 | 1397.770131 | 21.821194 | 0.333333 | 6 |
| 8627 | 8939 | C19180 | 728.352548 | 1.000000 | 734.40 | 734.40 | 0.00 | 239.891038 | 0.333333 | 0.333333 | 0.000000 | 0.166667 | 2 | 2 | 1000.0 | 72.530037 | 110.950798 | 0.000000 | 6 |
| 8628 | 8940 | C19181 | 130.838554 | 1.000000 | 591.24 | 0.00 | 591.24 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 475.523262 | 82.771320 | 1.000000 | 6 |
| 8629 | 8941 | C19182 | 5967.475270 | 0.833333 | 214.55 | 0.00 | 214.55 | 8555.409326 | 0.833333 | 0.000000 | 0.666667 | 0.666667 | 13 | 5 | 9000.0 | 966.202912 | 861.949906 | 0.000000 | 6 |
| 8630 | 8942 | C19183 | 40.829749 | 1.000000 | 113.28 | 0.00 | 113.28 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 94.488828 | 86.283101 | 0.250000 | 6 |
| 8631 | 8943 | C19184 | 5.871712 | 0.500000 | 20.90 | 20.90 | 0.00 | 0.000000 | 0.166667 | 0.166667 | 0.000000 | 0.000000 | 0 | 1 | 500.0 | 58.644883 | 43.473717 | 0.000000 | 6 |
| 8632 | 8945 | C19186 | 28.493517 | 1.000000 | 291.12 | 0.00 | 291.12 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 325.594462 | 48.886365 | 0.500000 | 6 |
| 8633 | 8947 | C19188 | 23.398673 | 0.833333 | 144.40 | 0.00 | 144.40 | 0.000000 | 0.833333 | 0.000000 | 0.666667 | 0.000000 | 0 | 5 | 1000.0 | 81.270775 | 82.418369 | 0.250000 | 6 |
| 8634 | 8948 | C19189 | 13.457564 | 0.833333 | 0.00 | 0.00 | 0.00 | 36.558778 | 0.000000 | 0.000000 | 0.000000 | 0.166667 | 2 | 0 | 500.0 | 52.549959 | 55.755628 | 0.250000 | 6 |
| 8635 | 8949 | C19190 | 372.708075 | 0.666667 | 1093.25 | 1093.25 | 0.00 | 127.040008 | 0.666667 | 0.666667 | 0.000000 | 0.333333 | 2 | 23 | 1200.0 | 63.165404 | 88.288956 | 0.000000 | 6 |